Kgtests: a simple Excel Macro program to detect signatures of population expansion using microsatellites

A simple Microsoft Excel Macro application (kgtests) that performs the k and g tests for detecting population expansion is described. The application, being an Excel Macro, facilitates the ease of preparation of the input file and makes it possible to use the application in any machine that can run Excel.     

Excel在微生物培养条件优化中的应用

根据正交试验设计的原理,采用Microsoft Excel软件编制优化微生物培养条件的程序,并以实例说明了该程序的使用方法。结果表明,用户只需输入试验的原始数据,即可快速、准确地进行直观分析和方差分析,并可根据极差值得出最佳工艺条件,从而大大提高微生物发酵的效率。     

阿托伐他汀对慢性阻塞性肺疾病合并肺动脉高压患者外周血ROCK2激酶活性及肺动脉压力的影响

目的：探讨口服阿托伐他汀片对慢性阻塞性肺疾病（chronic obstructive pulmonary Disease,COPD）合并肺动脉高压（pul-monary hypertension,PH）患者外周血ROCK2激酶活性及肺动脉压力的影响。方法：选取COPD合并PH患者60例为研究对象,并将其随机分为对照组（给予吸氧、抗感染、化痰、平喘等基础治疗）和阿托伐他汀治疗组（在基础治疗的基础上给予阿托伐他汀片20mg／d治疗）;随访观察周期12周,于试验开始前和结束后检测外周血ROCK2的活性,利用彩色多普勒检测肺动脉压力的变化,肺功能变化（测定FEV1,FVC）。结果：与对照组比较,阿托伐他汀治疗可显著降低患者血浆中ROCK2的水平（P〈0．01）;降低患者的肺动脉压力,改善患者的肺功能（FEV1,FVC）,P均〈0．05。结论：在常规吸氧、抗感染等治疗的基础上,联合应用阿托伐他汀可显著降低ROCK2激酶的活性和肺动脉压力,从而改善肺功能。     

利用Excel电子数据表计算遗传相似系数的方法

利用分子标记技术对生物物种群进行类群分类时,一般需要通过分析电泳图谱获得0/1矩阵,通过统计计算来得到其遗传相似系数和遗传距离指数。科学工作者常借助计算器徒手计算,容易出错,速度又慢。本文介绍一种以MicrosoftExcel电子数据表为平台,能较轻松又准确地根据0/1矩阵实现遗传相似系数和遗传距离指数计算的操作方法。     

用EXCEL中的VBA编写“多项式的三角函数拟合单峰曲线”程序

Excel是常用的电子表格处理软件,笔者采用基于Excel的VBA编程方法,编写了“多项式的三角函数拟合单峰曲线”程序,经教学科研工作中使用,获得了理想的效果。文中发表了该程序的源代码及使用方法,供广大科教人员下载使用。     

MapDraw，在Excel中绘制遗传连锁图的宏

MAPMAKER是现今广泛使用的遗传连锁数据分析软件,然而其广泛使用的DOS版本却不具有连锁图绘制功能,给连锁作图工作带来了相当大的麻烦。为了解决这一问题,我们以大家广泛使用的数据处理软件Microsoft Excel为平台,编写了一个Excel宏——MapDraw来在轻松的操作中实现遗传连锁图的绘制。 Abstract:MAPMAKER is one of the most widely used computer software package for constructing genetic linkage maps.However,the PC version,MAPMAKER 3.0 for PC,could not draw the genetic linkage maps that its Macintosh version,MAPMAKER 3.0 for Macintosh,was able to do.Especially in recent years,Macintosh computer is much less popular than PC.Most of the geneticists use PC to analyze their genetic linkage data.So a new computer software to draw the same genetic linkage maps on PC as the MAPMAKER for Macintosh to do on Macintosh has been crying for.Microsoft Excel,one component of Microsoft Office package,is one of the most popular software in laboratory data processing.Microsoft Visual Basic for Applications (VBA) is one of the most powerful functions of Microsoft Excel.Using this program language,we can take creative control of Excel,including genetic linkage map construction,automatic data processing and more.In this paper,a Microsoft Excel macro called MapDraw is constructed to draw genetic linkage maps on PC computer based on given genetic linkage data.Use this software,you can freely construct beautiful genetic linkage map in Excel and freely edit and copy it to Word or other application.This software is just an Excel format file.You can freely copy it from ftp://211.69.140.177 or ftp://brassica.hzau.edu.cn and the source code can be found in Excel′s Visual Basic Editor.     

The preparation of gelatine-embedded soil and litter sections and their application to some soil ecological studies

A method is described for preparing large gelatine-embedded soil sections for ecological studies. Sampling methods reduce structural disturbance of the samples to a minimum and include freezing the samples in the field to kill soil invertebrates in their natural micro-habitats. The samples are vacuum-embedded in gelatine and the construction of a simple embedding apparatus is described. Projects are suggested, suitable for upper secondary school or tertiary level education, where soil sections can be used to investigate various aspects of soil micro-arthropod ecology and the dynamics of organic matter in soil and litter profiles.     

Constructing a Pedotti diagram using excel charts

A method to draw a Pedotti or butterfly diagram is described using Microsoft Excel spreadsheets and charts without the need for knowledge in programming or special software.     

Excel和SAS在生物统计学的应用比较

对Excel和SAS在生物统计学的应用特点及存在问题进行了比较,指出Excel制作的统计图形美观Z函数可直接给出结果,公式编辑简便实用,具有“数据分析”功能,但也存在fx和“数据分析”结果不一致的地方,加载“数据分析”工具时需要插入“Microsoft Office”初始安装盘,不能进行平均数的多重比较以及高级试验统计的结果分析。SAS的生物统计功能齐全,操作界面直观,程序模式化;但与Excel相比,相对烦琐而复杂。因此,在生物统计教学和科研工作中,应针对所处理问题的性质和目的选用不同的统计分析软件。